Hi,

Does anyone know the MySQL Query for selecting all fields from a table where the fieldvalues do NOT equal nothing?

Thanks!

select * from `table` where `field` != "";should do it. I should think the type conversion would kick in if it were NULL as well.